package system.model;

import system.common.Constants;
import collector.core.util.StringUtil;

/**
 * <pre>
 * Class : system.model.DB3_DbIDto / DB3_DbIDto.java
 * 	Define Class Object : 
 * <br>
 * </pre>
 * @author hwanLee / apexcns,Inc.
 * @version 1.1
 * @see javadoc
 * @since 2012. 9. 10.
 */
public class DB3_DbIDto { 
	private String RcvID;
	private String DBIPFrom;
	private String DBIPTo;
	private String DBAccTimeReceived;
	private String DBAccTimeRequest;
	private String DBAccTimeResponse;
	private String DBContent;
	private String DBQueryType;
	private String DBDurationTime;
	private String DBSqlCode;
	private String DBSqlMessage;
	private String DBRowsAffect;
	private String DBTable;
	private String DBColumn;
	private String DBCommand;
	private String DBAlert;
	private String DBUID;
	private String DBLogType;
	private String programname;
	private String empname;
	private String PolicyName;

	/** <pre>
	 * Method : DB3_DbIDto.getRcvID()
	 * 	to get rcvID
	 * <br> 
	 * @return the rcvID : type of String
	 * </pre>
	 */
	public String getRcvID() {
		return RcvID;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setRcvID()
	 * 	to set rcvID
	 * <br> 
	 * @return the rcvID : type of String
	 * </pre>
	 */
	public void setRcvID(String rcvID) {
		this.RcvID = rcvID;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBIPFrom()
	 * 	to get dBIPFrom
	 * <br> 
	 * @return the dBIPFrom : type of String
	 * </pre>
	 */
	public String getDBIPFrom() {
		return DBIPFrom;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBIPFrom()
	 * 	to set dBIPFrom
	 * <br> 
	 * @return the dBIPFrom : type of String
	 * </pre>
	 */
	public void setDBIPFrom(String dBIPFrom) {
		this.DBIPFrom = dBIPFrom;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBIPTo()
	 * 	to get dBIPTo
	 * <br> 
	 * @return the dBIPTo : type of String
	 * </pre>
	 */
	public String getDBIPTo() {
		return DBIPTo;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBIPTo()
	 * 	to set dBIPTo
	 * <br> 
	 * @return the dBIPTo : type of String
	 * </pre>
	 */
	public void setDBIPTo(String dBIPTo) {
		this.DBIPTo = dBIPTo;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBAccTimeReceived()
	 * 	to get dBAccTimeReceived
	 * <br> 
	 * @return the dBAccTimeReceived : type of String
	 * </pre>
	 */
	public String getDBAccTimeReceived() {
		return DBAccTimeReceived;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBAccTimeReceived()
	 * 	to set dBAccTimeReceived
	 * <br> 
	 * @return the dBAccTimeReceived : type of String
	 * </pre>
	 */
	public void setDBAccTimeReceived(String dBAccTimeReceived) {
		this.DBAccTimeReceived = dBAccTimeReceived;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBAccTimeRequest()
	 * 	to get dBAccTimeRequest
	 * <br> 
	 * @return the dBAccTimeRequest : type of String
	 * </pre>
	 */
	public String getDBAccTimeRequest() {
		return DBAccTimeRequest;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBAccTimeRequest()
	 * 	to set dBAccTimeRequest
	 * <br> 
	 * @return the dBAccTimeRequest : type of String
	 * </pre>
	 */
	public void setDBAccTimeRequest(String dBAccTimeRequest) {
		this.DBAccTimeRequest = dBAccTimeRequest;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBAccTimeResponse()
	 * 	to get dBAccTimeResponse
	 * <br> 
	 * @return the dBAccTimeResponse : type of String
	 * </pre>
	 */
	public String getDBAccTimeResponse() {
		return DBAccTimeResponse;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBAccTimeResponse()
	 * 	to set dBAccTimeResponse
	 * <br> 
	 * @return the dBAccTimeResponse : type of String
	 * </pre>
	 */
	public void setDBAccTimeResponse(String dBAccTimeResponse) {
		this.DBAccTimeResponse = dBAccTimeResponse;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBContent()
	 * 	to get dBContent
	 * <br> 
	 * @return the dBContent : type of String
	 * </pre>
	 */
	public String getDBContent() {
		return DBContent;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBContent()
	 * 	to set dBContent
	 * <br> 
	 * @return the dBContent : type of String
	 * </pre>
	 */
	public void setDBContent(String dBContent) {
		this.DBContent = dBContent;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBQueryType()
	 * 	to get dBQueryType
	 * <br> 
	 * @return the dBQueryType : type of String
	 * </pre>
	 */
	public String getDBQueryType() {
		return DBQueryType;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBQueryType()
	 * 	to set dBQueryType
	 * <br> 
	 * @return the dBQueryType : type of String
	 * </pre>
	 */
	public void setDBQueryType(String dBQueryType) {
		this.DBQueryType = dBQueryType;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBDurationTime()
	 * 	to get dBDurationTime
	 * <br> 
	 * @return the dBDurationTime : type of String
	 * </pre>
	 */
	public String getDBDurationTime() {
		return DBDurationTime;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBDurationTime()
	 * 	to set dBDurationTime
	 * <br> 
	 * @return the dBDurationTime : type of String
	 * </pre>
	 */
	public void setDBDurationTime(String dBDurationTime) {
		this.DBDurationTime = dBDurationTime;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBSqlCode()
	 * 	to get dBSqlCode
	 * <br> 
	 * @return the dBSqlCode : type of String
	 * </pre>
	 */
	public String getDBSqlCode() {
		return DBSqlCode;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBSqlCode()
	 * 	to set dBSqlCode
	 * <br> 
	 * @return the dBSqlCode : type of String
	 * </pre>
	 */
	public void setDBSqlCode(String dBSqlCode) {
		this.DBSqlCode = dBSqlCode;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBSqlMessage()
	 * 	to get dBSqlMessage
	 * <br> 
	 * @return the dBSqlMessage : type of String
	 * </pre>
	 */
	public String getDBSqlMessage() {
		return DBSqlMessage;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBSqlMessage()
	 * 	to set dBSqlMessage
	 * <br> 
	 * @return the dBSqlMessage : type of String
	 * </pre>
	 */
	public void setDBSqlMessage(String dBSqlMessage) {
		this.DBSqlMessage = dBSqlMessage;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBRowsAffect()
	 * 	to get dBRowsAffect
	 * <br> 
	 * @return the dBRowsAffect : type of String
	 * </pre>
	 */
	public String getDBRowsAffect() {
		return DBRowsAffect;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBRowsAffect()
	 * 	to set dBRowsAffect
	 * <br> 
	 * @return the dBRowsAffect : type of String
	 * </pre>
	 */
	public void setDBRowsAffect(String dBRowsAffect) {
		this.DBRowsAffect = dBRowsAffect;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBTable()
	 * 	to get dBTable
	 * <br> 
	 * @return the dBTable : type of String
	 * </pre>
	 */
	public String getDBTable() {
		return DBTable;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBTable()
	 * 	to set dBTable
	 * <br> 
	 * @return the dBTable : type of String
	 * </pre>
	 */
	public void setDBTable(String dBTable) {
		this.DBTable = dBTable;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBColumn()
	 * 	to get dBColumn
	 * <br> 
	 * @return the dBColumn : type of String
	 * </pre>
	 */
	public String getDBColumn() {
		return DBColumn;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBColumn()
	 * 	to set dBColumn
	 * <br> 
	 * @return the dBColumn : type of String
	 * </pre>
	 */
	public void setDBColumn(String dBColumn) {
		this.DBColumn = dBColumn;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBCommand()
	 * 	to get dBCommand
	 * <br> 
	 * @return the dBCommand : type of String
	 * </pre>
	 */
	public String getDBCommand() {
		return DBCommand;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBCommand()
	 * 	to set dBCommand
	 * <br> 
	 * @return the dBCommand : type of String
	 * </pre>
	 */
	public void setDBCommand(String dBCommand) {
		this.DBCommand = dBCommand;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBAlert()
	 * 	to get dBAlert
	 * <br> 
	 * @return the dBAlert : type of String
	 * </pre>
	 */
	public String getDBAlert() {
		return DBAlert;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBAlert()
	 * 	to set dBAlert
	 * <br> 
	 * @return the dBAlert : type of String
	 * </pre>
	 */
	public void setDBAlert(String dBAlert) {
		this.DBAlert = dBAlert;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBUID()
	 * 	to get dBUID
	 * <br> 
	 * @return the dBUID : type of String
	 * </pre>
	 */
	public String getDBUID() {
		return DBUID;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBUID()
	 * 	to set dBUID
	 * <br> 
	 * @return the dBUID : type of String
	 * </pre>
	 */
	public void setDBUID(String dBUID) {
		this.DBUID = dBUID;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getDBLogType()
	 * 	to get dBLogType
	 * <br> 
	 * @return the dBLogType : type of String
	 * </pre>
	 */
	public String getDBLogType() {
		return DBLogType;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setDBLogType()
	 * 	to set dBLogType
	 * <br> 
	 * @return the dBLogType : type of String
	 * </pre>
	 */
	public void setDBLogType(String dBLogType) {
		this.DBLogType = dBLogType;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getProgramname()
	 * 	to get programname
	 * <br> 
	 * @return the programname : type of String
	 * </pre>
	 */
	public String getProgramname() {
		return programname;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setProgramname()
	 * 	to set programname
	 * <br> 
	 * @return the programname : type of String
	 * </pre>
	 */
	public void setProgramname(String programname) {
		this.programname = programname;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getEmpname()
	 * 	to get empname
	 * <br> 
	 * @return the empname : type of String
	 * </pre>
	 */
	public String getEmpname() {
		return empname;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setEmpname()
	 * 	to set empname
	 * <br> 
	 * @return the empname : type of String
	 * </pre>
	 */
	public void setEmpname(String empname) {
		this.empname = empname;
	}

	/** <pre>
	 * Method : DB3_DbIDto.getPolicyName()
	 * 	to get policyName
	 * <br> 
	 * @return the policyName : type of String
	 * </pre>
	 */
	public String getPolicyName() {
		return PolicyName;
	}

	/** <pre>
	 * Method : DB3_DbIDto.setPolicyName()
	 * 	to set policyName
	 * <br> 
	 * @return the policyName : type of String
	 * </pre>
	 */
	public void setPolicyName(String policyName) {
		this.PolicyName = policyName;
	}

	@Override
	public String toString() {
	    String delimiter = Constants.delimiter;

	    String res = StringUtil.rTrim(DBIPFrom) + delimiter;
	    res += StringUtil.rTrim(DBIPTo) + delimiter;
	    res += StringUtil.rTrim(DBAccTimeReceived) + delimiter;
	    res += StringUtil.rTrim(DBAccTimeRequest) + delimiter;
	    res += StringUtil.rTrim(DBAccTimeResponse) + delimiter;
	    res += StringUtil.convertColumnData(DBContent, 1) + delimiter;
	    res += StringUtil.rTrim(DBQueryType) + delimiter;
	    res += StringUtil.rTrim(DBDurationTime) + delimiter;
	    res += StringUtil.rTrim(DBSqlCode) + delimiter;
	    res += StringUtil.rTrim(DBRowsAffect) + delimiter;
	    res += StringUtil.rTrim(DBSqlMessage) + delimiter;	
	    res += StringUtil.rTrim(DBTable) + delimiter;
	    res += StringUtil.rTrim(DBColumn) + delimiter;
	    res += StringUtil.rTrim(DBCommand) + delimiter;
	    res += StringUtil.rTrim(DBAlert) + delimiter;
	    res += StringUtil.rTrim(empname) + delimiter;
	    res += StringUtil.rTrim(DBUID) + delimiter;
	    res += StringUtil.rTrim(DBLogType) + delimiter;
	    res += StringUtil.rTrim(PolicyName) + delimiter;
	    res += StringUtil.rTrim(programname) + "\n";
	    
	    return res;
	}
}
